﻿CREATE TABLE [dbo].[ProjectUnit] (
    [Id]        INT             IDENTITY (1, 1) NOT NULL,
    [ProjectId] INT             NOT NULL,
    [BlockNo]   VARCHAR (5)     NULL,
    [FloorNo]   VARCHAR (5)     NULL,
    [UnitNo]    VARCHAR (5)     NULL,
    [DoorPlate] VARCHAR (20)    NULL,
    [Layout]    VARCHAR (5)     NULL,
    [FloorSize] DECIMAL (18, 2) NULL,
    [BasePrice] DECIMAL (18, 2) NULL,
    CONSTRAINT [PK_ProjectUnit] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_ProjectUnit_Project] FOREIGN KEY ([ProjectId]) REFERENCES [dbo].[Project] ([Id])
);

